Age View Instructions 14

1. Right Click the NO IT Exp worksheet and Duplicate it.

2. Rename worksheet to Age


3. Remove all pills from the columns and shelves
4. In the Marks Card, remove Gender and drag and drop _cc.GenderMale>Female, in Color.
5. In the Marks Card remove cc.IT Exp% and drag and drop  _cc.AgeMeasure AVG in the marks card indetail.


6. Drag Age to Columns
7. Right click Null and select Hide.

8. Right Click Age Header and Select Hide Field Labels for Rows

 

9. Right Click in the sheet and Select Format.

10. Click on the Borders Icon and go down to Row Divider and select None.



11. Drag _cc.Age MEASURE into Rows twice, side by side.
12. Right Click the 2nd _cc.Age MEASURE and select dual Axis.


13. Make sure the 2nd _cc.Age MEASURE is highlighted. Go to it in the Marks card and change the Shape to Bar.


14. In the Marks Card, select Size and make the Bar skinny like a Petal.



15. Click on the First _cc.Age MEASURE in Rows. Make sure it is highlighted.
16. Go to the Marks Card and change it from Automatic to Circle.



17. Click on Size to make it bigger(around 50%), like the top of a Lollipop.



18. Make sure the First _cc.Age MEASURE  in Rows is Highlight. Press Ctrl and Drag _cc.Age MEASURE onto Text(Label)

 


19. Click on Text(label), then Alignment, then Select Automatic Center and Vertical Center


20. Again, make sure the First _cc.Age MEASURE  in Rosws is Highlight. In the Marks Card, Right Click cc.Age MEASURE   and Select Quick Table Calculation and Percent of Total.





21. In the Marks Card, right Click the Same Pill again and Select Format.

22. Go to Numbers, Percentage and 0 decimal places.



23. Right Click the Right Axis and Select Synchronize.



24. Then right click All 3 Axes and Uncheck Show Header.



25. Click on the top and select Entire View.

26. Right Click Title and select Hide Title




27.  Go to the Age Worksheet. Click on Worksheet and click on Show Title



28.  Right click title and select edit

29. Insert _cc.AgemeasureAVG and type the word Age afterwards


How to do Lollipop Charts in Tableau :